<%@ page language="java" import="java.util.*,java.sql.*,start.fly.test.database.*,java.awt.image.BufferedImage,java.io.InputStream,javax.imageio.ImageIO" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
 <head><title>相册管理</title>
    <script  src="../js/jquery-2.1.4.js"></script>
  
     <link rel="stylesheet" href="../css/lanrenzhijia.css" media="all">
           <link href="http://libs.baidu.com/bootstrap/3.0.3/css/bootstrap.min.css" rel="stylesheet">
   <script src="http://libs.baidu.com/bootstrap/3.0.3/js/bootstrap.min.js"></script>
<script>
jQuery(document).ready(function($) {
	$('.theme-login').click(function(){
		$('.theme-popover-mask').fadeIn(100);
		$('.theme-popover').slideDown(200);
	});
	$('.theme-poptit .close').click(function(){
		$('.theme-popover-mask').fadeOut(100);
		$('.theme-popover').slideUp(200);
	});
    
});
$(document).ready(function(){
	$('.user3').click(function(){
		$('#usernumber').attr("value",$(this).attr('id'));
	});
});
</script>
<style>
.divcss5{ border:1px solid ; width:200px; height:100px} 
</style>
</head>
<body >
<div style="padding-left: 15px;height:auto;width:99%;" >
<h1>相册管理</h1><hr>
<font size="5"><a href="">管理首页</a>&nbsp;&nbsp;<a href="add_user.jsp">新增</a>&nbsp;&nbsp;<a href="query_user.jsp">查询</a>&nbsp;&nbsp;<a href="">返回上一级</a></font>
    <div  >
<form action="person_number_list_delete.jsp" method="post" >
<table class="table table-bordered">
   <thead>
      <tr>
         
         <th>用户名</th>
         <th>图片</th>
         <th>删除</th>
      </tr>
   </thead>    
         <tbody> 
      <% 
  	linksql ls = new linksql();
  ls.link();
  ls.rs1 = ls.st.executeQuery("select count(*) from userinfo");
  ls.rs1.next();
  int row = ls.rs1.getInt(1);
  ls.rs1 = ls.st.executeQuery("select username,img from userinfo");
  ls.rs1.next();
  
  %>
                <%
    		for(int i=0;i<row;i++){
    	%>
    			<tr><td><%=ls.rs1.getString(1)%> </td>
    			<td><div class="divcss5"><img height="100" width="200" src='../img/<%=ls.rs1.getString(2)%>'/></div></td>
               <td><a href='../delete_photo?img=<%=ls.rs1.getString(2)%>'>删除</a></td>
               </tr>
    			<% 
    			ls.rs1.next();
    		}
    	%>
           
        
           </tbody>
    </table>
</form>
        </div>
    </div>
<script >
    $(document).ready(function(){

        $('#all').click(function(){
            $('input:checkbox[name]').prop('checked',this.checked);
        });

        $('input:checkbox[name]').click(function(){
            isall=$('input:checkbox[name]').length==$('input:checkbox[name]:checked').length;
            $('#all').prop('checked',isall);
        });
    });
</script>
<div class="theme-popover">
     <div class="theme-poptit">
          <a href="javascript:;" title="关闭" class="close">×</a>
          <h3></h3>
     </div>
     <div class="theme-popbod dform">
           <form class="theme-signin" name="loginform" action="user_update_do.jsp" method="post">
                <ol>
                     <li><strong>用户名：</strong><input class="ipt" type="text" name="username" value="" size="20" /></li>
                     <li><strong>email：</strong><input class="ipt" type="email" name="email" value="" size="20" /></li>
                     <li><input class="ipt" type="hidden" id="usernumber" name="usernumber"   /></li>
                     <li><input class="btn btn-primary" type="submit" name="submit" value=" 修改 " /></li>
                </ol>
           </form>
     </div>
</div>

</body>
</html>
